Exchange Rate
Description
The exchange rate .txt file is used for getting the exchange rate to convert one currency value into another currency type. It consists of the following fields:
| # | Field | Description |
|---|---|---|
| 1 | From | Source currency type |
| 2 | To | Target currency type |
| 3 | Exchange rate | Value to be multiplied |
Example
AED|CON|3.67250
AED|MWK|3.67250
ARS|CON|4.61650
ARS|MWK|4.61650
AUD|CON|1.03000
AUD|MWK|1.03000
In the above example, to get CON value from AED type, multiply AED with 3.67250.
Currency Parameters:
There are four types of currency related parameters used:
| # | parameter | Description | Example |
|---|---|---|---|
| 1 | src_local_ccy | source local currency | INR |
| 2 | display_local_ccy | display local currency | RUP |
| 3 | consol_ccy | consolidated currency | INR |
| 4 | is_consolidated | is consolidated flag | true or false |
Example: for a given input file, let us assume src_local_ccy=INR, display_local_ccy=RUP and consol_ccy=INR.
| Acc_No | Curr | Amt |
|---|---|---|
| 1111 | INR | 1000 |
| 2222 | USD | 2000 |
| 3333 | INR | 3000 |
CASE 1: If is_consolidated = true, then the given amount in 'Amt' field is of consol_ccy type , i.e, 2000 INR is given. While writing the output, the final consolidated amount will be in consol_ccy currency type. The native currency amount will be in native currency type. If the consolidated flag is set, i.e., the given amount is already of consolidated currency type, then for the 1.native currency amount, we make use of exhange rate and 2.final consolidated amount is directly summed. If the native currency type is of src_local_ccy, then we use display_local_ccy for distinguishing between native currency amount of src_local_ccy type and final consolidated amount.
| Curr | Amt | Description |
|---|---|---|
| RUP | 4000 | Native currency amount (with display_local_ccy) |
| USD | 24 | Native currency amount |
| INR | 6000 | Final consolidated amount |
CASE 2: If is_consolidated=false then the given amount in 'Amt' field is of 'Curr' field type , i.e, 2000 USD is given. While writing the output, the final consolidated amount will be in consol_ccy currency type. The native currency amount will be in native currency type. If the consolidated flag is unset, i.e., the given amount is in native currency type, then 1.the native currency is directly summed and 2.for the final consolidated amount, we make use of the exchange rate. If the native currency type is of src_local_ccy, then we use display_local_ccy for distinguishing between native currency amount of src_local_ccy type and final consolidated amount.
| Curr | Amt | Description |
|---|---|---|
| RUP | 4000 | Native currency amount (with display_local_ccy) |
| USD | 2000 | Native currency amount |
| INR | 168498 | Final consolidated amount |